Preferred Pharmacy

This builds a report of all issued medication by preferred pharmacy within a defined date period.

It initially lists all the staff members that issued scripts in the set date period.

You can then enter an x next to each member of staff you want to apply the search to using "Select User" column A.

Then when you click the 2nd button it lists all the preferred pharmacy scripts for that day entered by the selected staff member(s) (Input Operator).

It also creates a Pivot table showing counts for each Pharmacy. If the counts are double-clicked it will automatically create an individual report of the scripts for that pharmacy.

Full instructions are within the Excel report on the RULES sheet.

Download

• Pharmacy Report.xlsm